<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Export Reports preferences</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ul.whs2 { list-style:square; }
p.whs3 { margin-top:0px; margin-bottom:0px; margin-left:24px; text-indent:-24px; color:#000000; }
p.whs4 { margin-top:0px; margin-bottom:0px; text-indent:-24px; margin-left:24px; color:#000000; }
p.whs5 { font-weight:bold; text-indent:-156px; margin-left:0in; margin-top:0px; margin-bottom:0px; }
p.whs6 { margin-left:0in; margin-top:0px; margin-bottom:0px; }
p.whs7 { margin-left:80px; }
p.whs8 { font-weight:bold; }
ol.whs9 { list-style:disc; }
p.whs10 { margin-left:40px; }
p.whs11 { margin-left:0px; }
p.whs12 { text-indent:-50px; margin-left:50px; margin-top:0px; margin-bottom:0px; }
p.whs13 { text-indent:-50px; margin-left:50px; margin-top:0px; margin-bottom:0px; font-weight:bold; }
p.whs14 { text-indent:-50px; margin-left:50px; margin-top:6px; margin-bottom:6px; font-weight:normal; }
ul.whs15 { list-style:inside disc; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs3 {margin-top:1pt;margin-bottom:1pt;text-indent:1pt; }";
  strNSS += "p.whs4 {margin-top:1pt;margin-bottom:1pt;text-indent:1pt; }";
  strNSS += "p.whs5 {text-indent:1pt;margin-left:1pt;margin-top:1pt;margin-bottom:1pt; }";
  strNSS += "p.whs6 {margin-left:1pt;margin-top:1pt;margin-bottom:1pt; }";
  strNSS += "p.whs11 {margin-left:1pt; }";
  strNSS += "p.whs12 {text-indent:1pt;margin-top:1pt;margin-bottom:1pt; }";
  strNSS += "p.whs13 {text-indent:1pt;margin-top:1pt;margin-bottom:1pt; }";
  strNSS += "p.whs14 {text-indent:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Setting your preferences\nModifying user preferences\nExport Reports preferences");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Export Reports preferences</h1>
<p>The Export Reports preferences page allows you to specify exporting 
 preferences. Here, you can select the way that you want to export grids, 
 graphs and HTML documents. </p>
<p>When you export a report, you move a copy of the report into some other 
 software, such as Microsoft Excel, Abode PDF, or a simple text file. </p>
<p>Select<span style="font-weight: bold;"><B> Preferences </B></span>at the top 
 of any page, and then click <span style="font-weight: bold;"><B>Export Reports</B></span><span>. 
 </span></p>
<ul type="disc" class="whs1">
	
<li class=p><p><span style="font-weight: bold;"><B>Export</B></span>: From 
 the drop-down list, select either <span style="font-weight: bold;"><B>Whole 
 report </B></span><span>to export the entire report or</span><span style="font-weight: bold;"><B> 
 Portion displayed only</B></span> <span>to export only the portion of your 
 report displayed on your browser. This is a useful option if you commonly 
 view reports with name pages and only want to export the page you are 
 viewing. </span></p></li>
	
<li class=p><p><span style="font-weight: bold;"><B>Export grids to</B></span>: 
 </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p><span style="font-weight: bold;"><B>Excel with plain 
 text</B></span>: After export, the Microsoft Excel spreadsheet includes only 
 the text of the grid report. Report formatting as it appears in MicroStrategy 
 is not retained.</p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>CSV file format</B></span>: 
 After export, the contents of the grid report is displayed, separated 
 by commas. </p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Excel with formatting</B></span>: 
 After export, the grid report is displayed in an Excel spreadsheet and 
 retains all colors, fonts, and structure.</p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>HTML</B></span>: The 
 grid report is exported to an HTML file. </p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Plain text</B></span>: 
 The contents of the grid report are exported to plain text, and the <span 
 style="font-weight: bold;"><B>Delimiter</B></span> you specify separates data 
 from each cell of the report. </p></li>
	</ul>
	
<li class=p><p><span style="font-weight: bold;"><B>Export graphs to</B></span>: 
 </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p><span style="font-weight: bold;"><B>Excel with formatting</B></span>: 
 The graph report is opened in the version of Excel you specify in the 
 <span style="font-weight: bold;"><B>Excel version</B></span> drop-down list. 
 </p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>HTML</B></span>: The 
 graph report is exported to an HTML file. </p></li>
	</ul>
	
<li class=p><p><span style="font-weight: bold;"><B>Export HTML documents 
 to</B></span>: </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p><span style="font-weight: bold;"><B>HTML</B></span>: The 
 HTML document maintains its format, color, and structure when exported 
 to an HTML file. </p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Excel without formatting</B></span>: 
 Only grids from the HTML document are exported to plain text, giving users 
 access to the data within the grid reports. Graph reports in HTML documents 
 are not exported to Excel. </p></li>
	</ul>
	
<li class=p><p><span style="font-weight: bold;"><B>Export Report Title</B></span>: 
 The title of the report is included in the exported information.</p></li>
	
<li class=p><p><span style="font-weight: bold;"><B>Export Page-By Information</B></span><span>: 
 The objects grouped into a page-by are included in the exported information.</span></p></li>
	
<li class=p><p><span style="font-weight: bold;"><B>Export filter details</B></span>: 
 Choose whether or not to export the filter details on a report. If you 
 choose to export them, they appear above the exported report. </p></li>
	
<li class=p><p><span style="font-weight: bold;"><B>Export Header and Footer</B></span>: 
 Specify header and footer details by clicking <span style="font-weight: bold;"><B>Edit 
 Custom Settings</B></span>. </p></li>
	<ul type="square" class="whs2">
		
<li class=p><p><span style="font-weight: bold;"><B>Edit Custom Settings</B></span>: 
 Select header and footer settings from the <span style="font-weight: bold;"><B>Insert 
 Auto-text</B></span> drop-down list. Select a header placement option, located 
 below the <span style="font-weight: bold;"><B>Header</B></span> field.</p></li>
	</ul>
</ul>
<ul type="disc" class="whs1">
	
<li style=" color: #000000; " class=p><p class="whs3"><span style="font-weight: bold;"><B>Remove 
 extra column</B></span>: Determine whether the word Metrics appears on the 
 report.</p></li>
	
<li style=" color: #000000; " class=p><p class="whs4"><span style="font-weight: bold;"><B>Expand 
 all page-by fields</B></span>: Print all objects in the Page-by drop-down 
 lists when printing a report. To print only the objects currently displayed 
 (currently selected in the Page-by field), clear this check box. For an 
 introduction to page-by, see <span style="margin-left: 64px;">
<a href="Pageby.htm">Grouping 
 data by page: Page-by</a></span>.</p></li>
</ul>
<p class="whs5">&nbsp;</p>
<ul type="disc" class="whs1">
	
<li class=p><p class="whs6"><span 
 style="font-weight: bold;"><B>Excel options</B></span></p></li>
	<ul type="square" class="whs2">
		
<li class=p><p><span style="font-weight: bold;"><B>Excel version</B></span>: 
 Specify which version of Excel is used to export reports and documents. 
 The version you specify determines how version-specific situations, such 
 as European symbol formatting, are handled in Excel. </p></li>
	</ul>
</ul>
<p class="whs7"><span style="font-weight: bold;"><B>Note</B></span>: 
 The system defaults to <span style="font-weight: bold;"><B>Excel XP, Excel 
 2003 or newer versions</B></span>. The version of Excel you select determines 
 whether the export settings at the report level are considered or not.</p>
<ul type="disc" class="whs1">
	<ul type="square" class="whs2">
		
<li class=p><p><span style="font-weight: bold;"><B>Export metric values 
 as text</B></span>: Determine whether numeric values should be exported as 
 text or as numbers. If you choose to export metric values as numbers, 
 Excel may automatically format the number. For example, $34.23614 may 
 be rounded to $34.24 in Excel. If you choose to export metric values as 
 text, Excel will not automatically format the numbers. This setting only 
 applies to exports to Excel. </p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Export headers 
 as text</B></span>: Determine whether header values should be exported as 
 text or in their current format, which could be numeric, date, and so 
 on. This setting only applies to exports to Excel. </p></li>
	</ul>
	
<li class=p><p class="whs8">Excel with formatting options</p></li>
	<ul type="square" class="whs2">
		
<li class=p><p class="whs8">Place each page on a 
 separate sheet<span style="font-weight: normal;">: Determine if each page 
 of your report will be placed on its own Excel sheet. </span></p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Always export graphs</B></span> 
 <span style="font-weight: bold;"><B>as live Excel charts</B></span>: Determine 
 whether graph reports are exported as Excel charts on which you can perform 
 Excel manipulations just as you can on any graph in Excel. If you do not 
 enable this setting, graphs are exported to Excel as bitmaps. </p></li>
	</ul>
</ul>
<ol type="disc" class="whs9">
	<ul type="square" class="whs2">
		
<li class=p><p><span style="font-weight: bold;"><B>Embed images</B></span>: 
 Determine whether exported graphs and images from the report or document 
 are included in the Excel spreadsheet as images. If this check box is 
 selected, the images and graphs can be accessed from the spreadsheet with 
 out having to run MicroStrategy Web.</p></li>
	</ul>
</ol>
<p class="whs7"><span style="font-weight: bold;"><B>Note</B></span>: 
 Live charts are supported by all versions of Excel. Only Excel XP or later 
 versions support embedded images.</p>
<ul type="square" class="whs2">
	
<li class=p><p class="whs10"><span style="font-weight: bold;"><B>Allow 
 MicroStrategy Office to refresh Reports after exporting</B></span>: If you 
 have the MicroStrategy Office product, determine whether MicroStrategy 
 Office has the ability to refresh reports and documents after they have 
 been exported to Excel. This setting only applies to exports to Excel 
 with formatting. </p></li>
	
<li class=p><p class="whs11"><span style="font-weight: bold;"><B>Show 
 options when exporting</B></span>: Determine whether the Export Options page 
 opens each time you export a report. This allows you to easily change 
 export settings for each report you export, such as which format you want 
 to export to. </p></li>
	<ul>
<li style="list-style: square;" type=square class=p><p>If you select 
 this check box, the Export Options page opens each time you export a report. 
 </p></li>
		
<li style="list-style: square;" type=square class=p><p>If you clear 
 this check box, the Export Options page does not open when you export 
 a report. The report is exported with the settings you have saved in this 
 Export Reports preferences page of the User Preferences. </p></li>
	</ul>
</ul>
<p>From the drop-down list at the bottom of the page, apply the changes 
 to the current project or all projects you have access to that are stored 
 on the Intelligence Server and then click <span style="font-weight: bold;"><B>Apply</B></span>. 
 </p>
<p class="whs12">&nbsp;</p>
<p class="whs13">Warning: <span style="font-weight: normal;">Clicking</span> 
 Load Default Values <span style="font-weight: normal;">will reset all 
 of your preferences settings.</span></p>
<p class="whs14">&nbsp;</p>
<p class="whs14"><span style="text-indent: -50px; margin-left: 50px; margin-top: 0px; margin-bottom: 0px;"><span 
 style="font-weight: bold;"><B>Related topics</B></span></span></p>
<ul type="disc" class="whs15">
	
<li class=p><p class="whs14">
<a href="Exporting_a_grid_report.htm" 
 style="font-weight: normal;">Exporting a grid report</a></p></li>
	
<li class=p><p class="whs14">
<a href="Exporting_a_graph_report.htm" 
 style="font-weight: normal;">Exporting a graph report</a></p></li>
	
<li class=p><p class="whs14">
<a href="Export_a_document.htm" 
 style="font-weight: normal;">Exporting a document</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
